/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package test.db_work;

/**
 *
 * @author snbm
 */
public class Speciality_qualification {

    private String qualification_full;
    private String program_type;
    private String akadem_rights;
    private String profeccional_rights;
    private String diploma_name;
    private String study_period;

    @Override
    public String toString() {
        return new StringBuilder()
            .append("qualification_full (полное название квалификации) - " + qualification_full)
            .append("\nprogram_type (тип программы) - " + program_type)
            .append("\nakadem_rights (академ права) - " + akadem_rights)
            .append("\nprofeccional_rights (проф права) - " + profeccional_rights)
            .append("\ndiploma_name (название диплома) - " + diploma_name)
            .append("\nstudy_period (учебный период) - " + study_period)
            .toString();
    }

    public String make_INSERT_into_speciality_qualification(int kafedra_speciality_id) {
        return "INSERT INTO onpu.speciality_qualification VALUES (" + kafedra_speciality_id + ",'" + qualification_full + "','" + program_type + "',"
                + "'" + akadem_rights + "','" + profeccional_rights + "',"
                + "'" + diploma_name + "','" + study_period + "');";
    }

    /**
     * @return the qualification_full
     */
    public String getQualification_full() {
        return qualification_full;
    }

    /**
     * @param qualification_full the qualification_full to set
     */
    public void setQualification_full(String qualification_full) {
        this.qualification_full = qualification_full;
    }

    /**
     * @return the program_type
     */
    public String getProgram_type() {
        return program_type;
    }

    /**
     * @param program_type the program_type to set
     */
    public void setProgram_type(String program_type) {
        this.program_type = program_type;
    }

    /**
     * @return the akadem_rights
     */
    public String getAkadem_rights() {
        return akadem_rights;
    }

    /**
     * @param akadem_rights the akadem_rights to set
     */
    public void setAkadem_rights(String akadem_rights) {
        this.akadem_rights = akadem_rights;
    }

    /**
     * @return the profeccional_rights
     */
    public String getProfeccional_rights() {
        return profeccional_rights;
    }

    /**
     * @param profeccional_rights the profeccional_rights to set
     */
    public void setProfeccional_rights(String profeccional_rights) {
        this.profeccional_rights = profeccional_rights;
    }

    /**
     * @return the diploma_name
     */
    public String getDiploma_name() {
        return diploma_name;
    }

    /**
     * @param diploma_name the diploma_name to set
     */
    public void setDiploma_name(String diploma_name) {
        this.diploma_name = diploma_name;
    }

    /**
     * @return the study_period
     */
    public String getStudy_period() {
        return study_period;
    }

    /**
     * @param study_period the study_period to set
     */
    public void setStudy_period(String study_period) {
        this.study_period = study_period;
    }
}
